﻿<AdoNetDataAccess connection="$ContactsDBConnection$">
	<Sql>
		UPDATE Addresses
		SET typeId=@typeId,street1=@street1,street2=@street2,street3=@street3,city=@city,stateProvince=@stateProvince,zipCode=@zipCode,countryCode=@countryCode,
		longitude=@longitude, latitude=@latitude
		WHERE id=@id
	</Sql>
	<Sql type="SqlServer">
	</Sql>
	<Param name="id" type="UniqueIdentifier" />
	<Param name="type.id" dbName="typeId" type="UniqueIdentifier" />
	<Param name="street1" type="String" />
	<Param name="street2" type="String" />
	<Param name="street3" type="String" />
	<Param name="city" type="String" />
	<Param name="stateProvince" type="String" />
	<Param name="zipCode" type="String" />
	<Param name="country.regionCode" dbName="countryCode"  type="UnicodeVarChar" />
	<Param name="longitude" type="String" />
	<Param name="latitude" type="String" />
</AdoNetDataAccess>